/*
 Navicat Premium Data Transfer

 Source Server         : HOST
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : localhost:3306
 Source Schema         : dev_test_temp

 Target Server Type    : MySQL
 Target Server Version : 80023
 File Encoding         : 65001

 Date: 06/12/2021 16:02:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for menu_cust_order
-- ----------------------------
DROP TABLE IF EXISTS `menu_cust_order`;
CREATE TABLE `menu_cust_order` (
  `menu_id` int NOT NULL AUTO_INCREMENT COMMENT '目录id',
  `menu_pid` int DEFAULT NULL COMMENT '父级目录id',
  `menu_name` varchar(50) DEFAULT NULL COMMENT '目录名称',
  `menu_show` char(1) DEFAULT NULL COMMENT '是否展示：Y展示 N不展示',
  `menu_order` int DEFAULT NULL COMMENT '排序字段',
  `upd_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  `upd_tm` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  `crt_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `crt_tm` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`menu_id`),
  UNIQUE KEY `INDEX_ID_PID` (`menu_id`,`menu_pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户自定义目录表';

-- ----------------------------
-- Records of menu_cust_order
-- ----------------------------
BEGIN;
INSERT INTO `menu_cust_order` VALUES (1, 0, '目录1', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_cust_order` VALUES (2, 0, '目录2', 'Y', 3, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_cust_order` VALUES (3, 0, '目录3', 'Y', 5, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_cust_order` VALUES (4, 1, '目录1-1', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_cust_order` VALUES (5, 1, '目录1-2', 'Y', 6, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_cust_order` VALUES (6, 1, '目录1-3', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_cust_order` VALUES (7, 1, '目录1-4', 'Y', 5, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
COMMIT;

-- ----------------------------
-- Table structure for menu_order
-- ----------------------------
DROP TABLE IF EXISTS `menu_order`;
CREATE TABLE `menu_order` (
  `menu_id` int NOT NULL AUTO_INCREMENT COMMENT '目录id',
  `menu_pid` int DEFAULT NULL COMMENT '父级目录id',
  `menu_name` varchar(50) DEFAULT NULL COMMENT '目录名称',
  `menu_show` char(1) DEFAULT NULL COMMENT '是否展示：Y展示 N不展示',
  `menu_order` int DEFAULT NULL COMMENT '排序字段',
  `upd_by` varchar(50) DEFAULT NULL COMMENT '更新人',
  `upd_tm` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  `crt_by` varchar(50) DEFAULT NULL COMMENT '创建人',
  `crt_tm` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`menu_id`),
  UNIQUE KEY `INDEX_ID_PID` (`menu_id`,`menu_pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统目录表';

-- ----------------------------
-- Records of menu_order
-- ----------------------------
BEGIN;
INSERT INTO `menu_order` VALUES (1, 0, '目录1', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_order` VALUES (2, 0, '目录2', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_order` VALUES (3, 0, '目录3', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_order` VALUES (4, 1, '目录1-1', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_order` VALUES (5, 1, '目录1-2', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_order` VALUES (6, 1, '目录1-3', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
INSERT INTO `menu_order` VALUES (7, 1, '目录1-4', 'Y', 1, '', NULL, 'xiaoming', '2021-12-06 15:04:01');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
